package net.mingsoft.expertmanage.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import net.mingsoft.expertmanage.entity.ProjectEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

/**
 * 项目管理数据访问接口
 */
@Mapper
public interface ProjectDao extends BaseMapper<ProjectEntity> {
    
    /**
     * 获取最大序号值
     * @return 最大序号值，如果没有记录则返回null
     */
    @Select("SELECT MAX(serial_no) FROM project_info")
    Integer getMaxSerialNo();
} 